Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | SupplierItem(AS_ITM_SPR) |
SupplierItemID (FK)(PK) | The code assigned by the supplier to uniquely identify the ITEM | ID_ITM_SPR | Identity | integer | SupplierItem(AS_ITM_SPR) |
CountryOriginTypeCode (FK)(PK) | A code that identifies the country of origin. The ISO country code standard is recommended as the value list for this attribute type. | CD_CY_ORG | ISOCountryCode | CHAR(3) | CountryOriginRoleType(LU_CY_ORG_RO_TY) |
ISOCountryCode (FK) | The ISO-3166-1 two letter code denoting a locality in which the retailer does business. | CD_CY_ISO | Code2 | char(2) | ISO3166-1Country(LO_CY_ISO) |